﻿
CREATE TABLE [dbo].[Payroll](
	[EmpID] [int] NOT NULL,
	[PayPeriod] [date] NULL,
	[PayDate] [date] NULL,
	[Percentage] [float] NULL,
	[ClientRate] [float] NULL,
	[ActualRate] [float] NULL,
	[PaidRate] [float] NULL,
	[Difference] [float] NULL,
	[HoursWorkedCurrentMonth] [int] NULL,
	[HoursPaidWithHold] [int] NULL,
	[TotalHoursPaid] [float] NULL,
	[CurrentMonthWithHoldAmount] [float] NULL,
	[WithHoldBalanceForward] [float] NULL,
	[SalaryFromWithHold] [float] NULL,
	[PerDiem_otherPayWithHeld] [float] NULL,
	[Bonus] [float] NULL,
	[BalanceWithHeldAmount] [float] NULL,
	[FilingFeeDeduction] [float] NULL,
	[OtherAdjustment] [float] NULL,
	[Total] [float] NULL,
	[ToPayBonus] [float] NULL,
	[RequireWithHodling] [nchar](10) NULL,
	[AccountReceivableAmount] [float] NULL
) ON [PRIMARY]

GO

